Conditional Calculations and Practical Examples in Tableau

Topic: Conditional Calculations and Practical Examples

Objective: Learn how to create conditional calculations in Tableau using IF, ELSEIF, ELSE, IIF, CASE, logical operators, and practical business scenarios. These calculations help classify data, evaluate business rules, create performance categories, identify profitable orders, and build interactive dashboards.

1. Introduction to Conditional Calculations

Conditional calculations in Tableau are formulas that evaluate a condition and return a result depending on whether that condition is satisfied. They allow analysts to apply business rules directly to data and transform raw values into meaningful categories.

For example, a company may want to classify sales as High, Medium, or Low. Instead of manually reviewing every sales record, Tableau can evaluate the Sales field and automatically assign the appropriate category.

Example

IF [Sales] >= 10000 THEN "High Sales"
ELSE "Low Sales"
END

Explanation: If Sales is at least 10,000, Tableau returns High Sales. Otherwise, it returns Low Sales.

Why Conditional Calculations Are Important

• Classify numerical values into meaningful groups.
• Identify profitable and unprofitable transactions.
• Measure whether sales targets have been achieved.
• Separate customers into different segments.
• Highlight high-performing and low-performing products.
• Create custom KPIs and business metrics.
• Control the values displayed in charts and dashboards.
• Apply consistent business rules to large datasets.

2. Understanding the Basic Structure

The most common conditional calculation uses IF, THEN, ELSE, and END.

IF condition THEN result
ELSE alternative_result
END

Example with a complete calculation

IF [Sales] >= 5000 THEN "Target Achieved"
ELSE "Target Not Achieved"
END

When Sales equals 6,000, the result is Target Achieved. When Sales equals 3,000, the result is Target Not Achieved.

3. Creating a Calculated Field in Tableau

A calculated field allows you to create a new value using an expression based on existing fields in your data source.

Steps to Create a Conditional Calculation

1. Open Tableau Desktop or Tableau Cloud with an appropriate workbook.
2. Connect to a dataset containing fields such as Sales, Profit, Category, Region, or Order Date.
3. Open a worksheet.
4. In the Data pane, right-click an empty area or use the Analysis menu.
5. Select Create Calculated Field.
6. Enter a descriptive name, such as Sales Performance Category.
7. Write the conditional formula in the calculation editor.
8. Check whether Tableau reports a valid calculation.
9. Click Apply or OK.
10. Drag the calculated field into Rows, Columns, Marks, Filters, or Label, depending on your analysis.
11. Review the results and test the calculation with different records.

Example: Sales Performance Category

IF [Sales] >= 10000 THEN "High"
ELSEIF [Sales] >= 5000 THEN "Medium"
ELSE "Low"
END

Save the calculation as Sales Performance Category. Drag it to Rows and SUM(Sales) to Columns to compare sales across the three groups.

Important: The field names used in a formula must exist in your dataset, unless you create the fields separately. The examples in these notes assume a dataset with the required fields.

4. IF Statements

The IF statement checks a logical condition. If the condition is true, Tableau returns the value specified after THEN. An ELSE clause can provide a default result.

Syntax

IF condition THEN result
ELSE alternative_result
END

Example 1: Identify Profitable Orders

IF [Profit] > 0 THEN "Profitable"
ELSE "Not Profitable"
END

Explanation: Positive profit is classified as Profitable. Zero or negative profit is classified as Not Profitable.

Example 2: Identify High Sales

IF [Sales] > 10000 THEN "High Sales"
ELSE "Regular Sales"
END

Example 3: Identify Discounted Orders

IF [Discount] > 0 THEN "Discount Applied"
ELSE "No Discount"
END

Example 4: Identify Orders Above a Quantity Threshold

IF [Quantity] >= 10 THEN "Bulk Order"
ELSE "Regular Order"
END

When to Use IF

• When a calculation must evaluate a logical expression.
• When conditions use comparisons such as greater than, less than, or equal to.
• When conditions involve multiple fields.
• When different branches need different logical tests.

5. ELSEIF for Multiple Conditions

ELSEIF lets Tableau evaluate additional conditions when the preceding condition is false. Tableau returns the result associated with the first true condition.

Syntax

IF condition_1 THEN result_1
ELSEIF condition_2 THEN result_2
ELSEIF condition_3 THEN result_3
ELSE default_result
END

Example 1: Sales Performance Classification

IF [Sales] >= 15000 THEN "Excellent"
ELSEIF [Sales] >= 10000 THEN "Good"
ELSEIF [Sales] >= 5000 THEN "Average"
ELSE "Needs Improvement"
END

Explanation: Sales of 16,000 returns Excellent. Sales of 12,000 returns Good. Sales of 7,000 returns Average. Sales of 3,000 returns Needs Improvement.

Example 2: Profit Classification

IF [Profit] > 5000 THEN "High Profit"
ELSEIF [Profit] > 0 THEN "Low Profit"
ELSEIF [Profit] = 0 THEN "Break-Even"
ELSE "Loss"
END

Example 3: Customer Segmentation by Sales

IF [Sales] >= 20000 THEN "Premium Customer"
ELSEIF [Sales] >= 10000 THEN "Regular Customer"
ELSE "Low-Value Customer"
END

Example 4: Discount Classification

IF [Discount] >= 0.30 THEN "High Discount"
ELSEIF [Discount] >= 0.15 THEN "Medium Discount"
ELSEIF [Discount] > 0 THEN "Low Discount"
ELSE "No Discount"
END

Note: If Discount is stored as a decimal, 0.30 represents 30%. Confirm the format and values in your actual dataset before applying thresholds.

Why Condition Order Matters

Conditions should generally be ordered from the most restrictive or highest threshold to the lowest when classifying ranges.

Incorrect example:

IF [Sales] > 5000 THEN "Medium"
ELSEIF [Sales] > 10000 THEN "High"
ELSE "Low"
END

The High condition will never be reached for sales above 10,000 because those records already satisfy Sales > 5000.

Correct example:

IF [Sales] > 10000 THEN "High"
ELSEIF [Sales] > 5000 THEN "Medium"
ELSE "Low"
END

6. ELSE and Default Results

ELSE specifies what Tableau should return when none of the preceding conditions is true. It is optional in an IF expression, but including it often makes results easier to understand.

Example with ELSE

IF [Sales] >= 5000 THEN "Target Achieved"
ELSE "Target Not Achieved"
END

Example without ELSE

IF [Sales] >= 5000 THEN "Target Achieved"
END

If Sales is below 5,000, the calculation returns NULL because no ELSE result is provided and the condition is false.

Best Practice

• Use ELSE to make the treatment of unmatched values explicit.
• Use a meaningful label such as "Other", "Below Target", or "Unclassified" where appropriate.
• Do not automatically classify missing data as zero or as a failure unless that matches the business definition.

7. IIF Function

IIF is a compact conditional function that evaluates a test and returns one value when true and another when false. It can also accept an optional result for an unknown condition.

Syntax

IIF(test, then, else, [unknown])

Example 1: Sales Target

IIF([Sales] >= 5000, "Achieved", "Not Achieved")

Example 2: Profit Status

IIF([Profit] > 0, "Profit", "No Positive Profit")

Example 3: Handle an Unknown Condition

IIF([Profit] > 0, "Profit", "Not Profit", "Unknown")

The optional fourth argument is used when the test evaluates to unknown, such as when a required value is NULL. Without the optional argument, an unknown test can return NULL.

IF versus IIF

8. CASE Statements

CASE compares one expression against a set of specified values and returns the result associated with the first matching value. It is especially useful when classifying one categorical field.

Syntax

CASE expression
WHEN value_1 THEN result_1
WHEN value_2 THEN result_2
WHEN value_3 THEN result_3
ELSE default_result
END

Example 1: Product Category Classification

CASE [Category]
WHEN "Furniture" THEN "Home Products"
WHEN "Office Supplies" THEN "Business Supplies"
WHEN "Technology" THEN "Electronic Products"
ELSE "Other Products"
END

Example 2: Region Grouping

CASE [Region]
WHEN "East" THEN "Eastern Region"
WHEN "West" THEN "Western Region"
WHEN "Central" THEN "Central Region"
WHEN "South" THEN "Southern Region"
ELSE "Other Region"
END

Example 3: Shipping Mode Labels

CASE [Ship Mode]
WHEN "Same Day" THEN "Urgent Delivery"
WHEN "First Class" THEN "Fast Delivery"
WHEN "Second Class" THEN "Standard Delivery"
WHEN "Standard Class" THEN "Economy Delivery"
ELSE "Unclassified Delivery"
END

Example 4: Month Name Classification

CASE DATEPART('month', [Order Date])
WHEN 1 THEN "January"
WHEN 2 THEN "February"
WHEN 3 THEN "March"
WHEN 4 THEN "April"
WHEN 5 THEN "May"
WHEN 6 THEN "June"
WHEN 7 THEN "July"
WHEN 8 THEN "August"
WHEN 9 THEN "September"
WHEN 10 THEN "October"
WHEN 11 THEN "November"
WHEN 12 THEN "December"
END

CASE versus IF

9. Combining Conditions with AND, OR, and NOT

Logical operators allow a conditional calculation to evaluate more than one requirement.

AND Operator

AND returns true only when both conditions are true.

IF [Sales] >= 10000 AND [Profit] > 0 THEN "High Sales and Profitable"
ELSE "Other"
END

This identifies records where Sales is at least 10,000 and Profit is positive.

OR Operator

OR returns true when at least one condition is true.

IF [Sales] >= 10000 OR [Profit] > 5000 THEN "Priority Record"
ELSE "Regular Record"
END

NOT Operator

NOT reverses a logical result.

IF NOT ([Category] = "Furniture") THEN "Non-Furniture"
ELSE "Furniture"
END

Combined Business Rule

IF [Sales] >= 10000
AND [Profit] > 0
AND [Discount] < 0.20
THEN "Preferred Order"
ELSE "Review Order"
END

This rule identifies orders that meet all three criteria: high sales, positive profit, and a discount below 20%.

Practical Tip

Use parentheses when combining AND and OR to make the intended evaluation order clear.

IF ([Region] = "East" OR [Region] = "West")
AND [Sales] > 5000
THEN "Qualified Sale"
ELSE "Other Sale"
END

10. Comparison Operators Used in Conditional Calculations

Example: Detect Low-Profit Orders

IF [Profit] < 0 THEN "Loss-Making"
ELSEIF [Profit] = 0 THEN "Break-Even"
ELSE "Profitable"
END

11. Practical Example 1: Sales Performance Analysis

Business requirement: A sales manager wants to classify orders into performance levels to understand how much revenue comes from each group.

Calculated Field: Sales Performance

IF [Sales] >= 15000 THEN "Excellent"
ELSEIF [Sales] >= 10000 THEN "Good"
ELSEIF [Sales] >= 5000 THEN "Average"
ELSE "Low"
END

Sample Data

How to Visualize It

1. Drag Sales Performance to Rows.
2. Drag Sales to Columns and use SUM(Sales).
3. Choose a bar chart from Show Me.
4. Drag Sales Performance to Color in the Marks card.
5. Drag SUM(Sales) to Label if you want to display the values.
6. Sort the categories or add filters as required.

Business value: Managers can quickly see which performance category contributes the most revenue and investigate weaker categories.

12. Practical Example 2: Profit and Loss Analysis

Business requirement: The finance team wants to separate profitable, break-even, and loss-making records.

Calculated Field: Profit Status

IF [Profit] > 0 THEN "Profit"
ELSEIF [Profit] = 0 THEN "Break-Even"
ELSE "Loss"
END

Sample Results

Visualization Steps

1. Drag Profit Status to Rows.
2. Drag Profit to Columns and select SUM(Profit).
3. Choose a bar chart.
4. Drag Profit Status to Color.
5. Optionally place Region or Category on Filters to investigate particular areas.

Important: A record-level profit label and an aggregated profit label are not necessarily equivalent. If you need to classify the total profit for each region, first define the intended aggregation and then construct the calculation at the appropriate level.

13. Practical Example 3: Target Achievement

Business requirement: A company sets a sales target of 10,000 for each record or entity being evaluated.

Calculated Field: Target Status

IF [Sales] >= 10000 THEN "Target Achieved"
ELSE "Target Not Achieved"
END

Percentage of Target

If your dataset includes a field named Target, create the following calculated field:

IF [Target] > 0 THEN [Sales] / [Target]
ELSE NULL
END

Name it Target Achievement Rate and format it as a percentage. For example, Sales of 8,000 against a target of 10,000 produces an achievement rate of 80%.

Achievement Categories

IF [Target] <= 0 THEN "Target Not Defined"
ELSEIF [Sales] >= [Target] THEN "Achieved"
ELSEIF [Sales] >= [Target] * 0.75 THEN "Near Target"
ELSE "Below Target"
END

Business value: The sales team can identify targets that are achieved, nearly achieved, or substantially missed.

14. Practical Example 4: Customer Segmentation

Business requirement: A marketing team wants to group customers by their sales contribution.

Calculated Field: Customer Segment

IF [Sales] >= 25000 THEN "VIP"
ELSEIF [Sales] >= 10000 THEN "Regular"
ELSE "Occasional"
END

This example assumes each record's Sales value is appropriate for the segmentation. If the goal is to segment customers by their total lifetime or total-period sales, calculate sales at the customer level rather than classifying individual order rows.

Customer-Level Sales Using an LOD Expression

{ FIXED [Customer ID] : SUM([Sales]) }

Save this expression as Customer Total Sales. Then create a customer segment calculated field:

IF [Customer Total Sales] >= 25000 THEN "VIP"
ELSEIF [Customer Total Sales] >= 10000 THEN "Regular"
ELSE "Occasional"
END

Note: FIXED level-of-detail expressions have their own filter-order behavior. Review Tableau's order of operations if the customer totals must respond to particular filters.

Suggested Visualization

• Use Customer Segment on Rows.
• Use COUNTD(Customer ID) to count distinct customers in each segment.
• Use Customer Segment on Color.
• Add Region or Segment filters to compare customer groups.

15. Practical Example 5: Discount Risk Analysis

Business requirement: A business wants to identify transactions that receive high discounts.

Calculated Field: Discount Risk

IF [Discount] >= 0.30 THEN "High Discount"
ELSEIF [Discount] >= 0.15 THEN "Medium Discount"
ELSEIF [Discount] > 0 THEN "Low Discount"
ELSE "No Discount"
END

Calculated Field: Review Flag

IF [Discount] >= 0.30 AND [Profit] < 0 THEN "Review Required"
ELSE "No Flag"
END

Business value: Analysts can find transactions with both high discounts and negative profit for further investigation. A flag identifies records for review; it does not automatically prove that a transaction is incorrect.

16. Practical Example 6: Conditional Date Calculations

Conditional calculations can evaluate dates to classify records by period or deadline.

Example 1: Order Period

IF DATEPART('month', [Order Date]) <= 3 THEN "Q1"
ELSEIF DATEPART('month', [Order Date]) <= 6 THEN "Q2"
ELSEIF DATEPART('month', [Order Date]) <= 9 THEN "Q3"
ELSE "Q4"
END

This classifies dates into calendar quarters. If your business follows a different fiscal calendar, adjust the logic accordingly.

Example 2: Recent Orders

IF [Order Date] >= DATEADD('day', -30, TODAY())
AND [Order Date] <= TODAY()
THEN "Last 30 Days"
ELSE "Outside Last 30 Days"
END

This example uses the current date to identify dates from the last 30 days through today. The result changes as TODAY() changes. Consider date-time values and your reporting time zone when using this calculation.

Example 3: Delivery Deadline

If your data contains Order Date and Ship Date, you can classify shipping duration:

IF DATEDIFF('day', [Order Date], [Ship Date]) <= 2 THEN "Fast Shipping"
ELSEIF DATEDIFF('day', [Order Date], [Ship Date]) <= 5 THEN "Standard Shipping"
ELSE "Slow Shipping"
END

This example classifies the difference between the two dates. It does not establish whether a delivery met its promised deadline unless the relevant deadline field is included.

17. Practical Example 7: Conditional Revenue Calculations

Conditional calculations can return a measure only when a record meets a specified condition.

Example 1: Sales from Technology

IF [Category] = "Technology" THEN [Sales]
ELSE 0
END

To calculate total Technology sales in a view, use SUM of this calculated field.

Example 2: Profit from Profitable Records

IF [Profit] > 0 THEN [Profit]
ELSE 0
END

This returns positive profit for profitable records and zero for other records. It does not calculate net profit because negative-profit values are excluded from the result.

Example 3: Count Qualified Orders

IF [Sales] >= 10000 THEN 1
ELSE 0
END

Name the field Qualified Order Flag. Use SUM(Qualified Order Flag) to count qualifying rows. If each order can appear in multiple rows, use an order-level calculation or a distinct-order counting approach to avoid overcounting.

Example 4: Conditional Sales by Region

IF [Region] = "East" THEN [Sales]
ELSE 0
END

Use SUM of this field to calculate sales attributed to East. This is useful when building targeted measures, though a standard Region filter or a view broken down by Region may be simpler for some analyses.

18. Handling NULL Values in Conditional Calculations

NULL represents a missing or unknown value. It is not automatically equivalent to zero, an empty string, or false. Conditional logic should handle missing values according to the business requirement.

Using IFNULL

IFNULL([Profit], 0)

This returns Profit when it is not NULL and returns zero when it is NULL.

Using ISNULL

IF ISNULL([Sales]) THEN "Missing Sales"
ELSE "Sales Available"
END

Using ZN

ZN([Sales])

ZN returns the expression when it is not NULL; otherwise, it returns zero. Use this only when treating missing values as zero is appropriate.

Conditional Calculation with Explicit NULL Handling

IF ISNULL([Profit]) THEN "Profit Missing"
ELSEIF [Profit] > 0 THEN "Profit"
ELSEIF [Profit] = 0 THEN "Break-Even"
ELSE "Loss"
END

Important: Replacing NULL with zero can affect averages, totals, ratios, and business conclusions. Confirm what missing data means before making that replacement.

19. Aggregate Calculations and Conditional Logic

Tableau calculations can operate on individual rows or aggregated measures. The correct approach depends on the question you want to answer.

Row-Level Classification

IF [Profit] > 0 THEN "Profitable Row"
ELSE "Non-Profitable Row"
END

This evaluates the Profit value for each underlying record.

Aggregated Profit Classification

IF SUM([Profit]) > 0 THEN "Positive Total Profit"
ELSEIF SUM([Profit]) = 0 THEN "Zero Total Profit"
ELSE "Negative Total Profit"
END

This evaluates total Profit at the aggregation level of the view. The result may differ from classifying individual records because profitable and loss-making rows can offset one another.

Example: Compare the Two Questions

• Row-level question: Which transactions have positive profit?
• Aggregated question: Does each displayed region have positive total profit?

Choose the calculation that matches the question. Avoid mixing aggregated and non-aggregated fields in one expression unless Tableau's calculation rules permit the expression or the fields are made consistent.

20. Practical Example 8: Dynamic Measure Selection

CASE can be used with a parameter to let dashboard users choose which measure to display. This example assumes you create a string parameter named Choose a Measure with options Sales, Profit, and Quantity.

Calculated Field: Selected Measure

CASE [Choose a Measure]
WHEN "Sales" THEN SUM([Sales])
WHEN "Profit" THEN SUM([Profit])
WHEN "Quantity" THEN SUM([Quantity])
END

Place Selected Measure in the view and show the parameter control. Users can switch the measure without creating a separate chart for each option.

Important: The parameter's values must match the text used in the CASE expression. The returned branches must also have compatible data types. In this example, all branches return numeric values.

21. Practical Example 9: Conditional KPI Classification

Business requirement: Create a KPI label based on total sales in the current view.

Calculated Field: Sales KPI Status

IF SUM([Sales]) >= 100000 THEN "Above Target"
ELSEIF SUM([Sales]) >= 75000 THEN "Near Target"
ELSE "Below Target"
END

This calculation evaluates the aggregated sales in the current view. Its output can change when dimensions or filters change the level of aggregation or the data included in the view.

Suggested Dashboard Elements

• A KPI card showing SUM(Sales).
• A label displaying Sales KPI Status.
• A bar chart comparing sales by Region.
• A filter for Order Date.
• A category breakdown for additional context.

22. Practical Example 10: Build a Conditional Sales Dashboard

This mini-project combines multiple conditional calculations into one business dashboard.

Project Objective

Create a dashboard that helps a sales manager analyze sales performance, profitability, target achievement, and discount risk.

Step 1: Create Sales Performance

IF [Sales] >= 15000 THEN "Excellent"
ELSEIF [Sales] >= 10000 THEN "Good"
ELSEIF [Sales] >= 5000 THEN "Average"
ELSE "Low"
END

Step 2: Create Profit Status

IF [Profit] > 0 THEN "Profit"
ELSEIF [Profit] = 0 THEN "Break-Even"
ELSE "Loss"
END

Step 3: Create Discount Risk

IF [Discount] >= 0.30 AND [Profit] < 0 THEN "Review Required"
ELSE "No Flag"
END

Step 4: Create a Qualified Order Flag

IF [Sales] >= 10000 AND [Profit] > 0 THEN 1
ELSE 0
END

Use SUM(Qualified Order Flag) to count qualifying rows. Confirm whether each row represents one order before interpreting the result as an order count.

Step 5: Build Worksheets

1. Create a bar chart for Sales by Sales Performance.
2. Create a profit chart grouped by Profit Status.
3. Create a chart showing the number of records requiring discount review.
4. Create a region comparison using SUM(Sales).
5. Add relevant filters such as Region, Category, and Order Date.

Step 6: Assemble the Dashboard

1. Create a new dashboard.
2. Place the sales performance chart at the top or left.
3. Add the profit and loss chart.
4. Add the discount-risk chart.
5. Add region and date filters.
6. Use informative titles and labels.
7. Test filter interactions and validate the calculations against the source data.

Expected Outcome

The dashboard should help users identify strong sales categories, areas with negative profit, orders that may need review, and differences in performance across regions. Actual results depend on the connected dataset.

23. Common Errors and Troubleshooting

24. Best Practices for Conditional Calculations

• Give every calculated field a meaningful name.
• Use IF for logical conditions and CASE for matching one expression to several known values.
• Use IIF for simple true/false conditions when its NULL behavior is suitable.
• Order overlapping thresholds carefully.
• Include an ELSE result when unmatched records need a defined classification.
• Handle NULL values intentionally rather than automatically treating them as zero.
• Use parentheses to clarify complicated combinations of AND and OR.
• Keep the result data type consistent across all branches.
• Test values at the exact boundaries, such as 4,999, 5,000, and 5,001.
• Verify whether the calculation should operate on individual rows or aggregated values.
• Validate totals and classifications against sample records.
• Use concise formulas and avoid unnecessary nested conditions.
• Document important business rules so other workbook users can understand them.

25. Practice Exercises

Use a dataset containing fields such as Sales, Profit, Discount, Quantity, Region, Category, Customer ID, Order Date, and Ship Mode where available.

Beginner Exercises

1. Create a calculated field that labels Sales above 5,000 as High and all other sales as Low.
2. Classify Profit as Profit or Loss, treating zero as Break-Even.
3. Identify orders with a discount greater than zero.
4. Use CASE to group product categories into custom labels.
5. Identify orders with Quantity of at least 10.

Intermediate Exercises

1. Classify Sales into Excellent, Good, Average, and Low groups.
2. Classify discounts into Low, Medium, and High categories.
3. Create a conditional flag for records with Sales above 10,000 and positive Profit.
4. Identify orders shipped within two days, within five days, or later.
5. Create a label that identifies missing Profit values before classifying profit status.

Advanced Exercises

1. Create a customer segment using total sales per customer rather than individual order sales.
2. Build a KPI classification using SUM(Sales).
3. Create a parameter-driven measure selector using CASE.
4. Build a dashboard that compares sales performance and profit status by region.
5. Investigate how filters affect your conditional calculations and document the results.

Exercise Answer Samples

Exercise 1:

IF [Sales] > 5000 THEN "High"
ELSE "Low"
END

Exercise 2:

IF [Profit] > 0 THEN "Profit"
ELSEIF [Profit] = 0 THEN "Break-Even"
ELSE "Loss"
END

Exercise 3:

IF [Discount] > 0 THEN "Discount Applied"
ELSE "No Discount"
END

Exercise 4:

CASE [Category]
WHEN "Furniture" THEN "Home"
WHEN "Office Supplies" THEN "Office"
WHEN "Technology" THEN "Electronics"
ELSE "Other"
END

Exercise 5:

IF [Quantity] >= 10 THEN "Bulk"
ELSE "Standard"
END

26. Tableau Conditional Calculations Interview Questions and Answers

Q1. What are conditional calculations in Tableau?

Answer: They are calculations that evaluate conditions and return values based on the outcome. They are used to classify records, apply business rules, and create custom metrics.

Q2. What is the purpose of an IF statement?

Answer: IF evaluates a logical condition and returns a specified result when the condition is true. ELSEIF can add further conditions, and ELSE can define a default result.

Q3. What is the difference between IF and ELSEIF?

Answer: IF begins the conditional statement. ELSEIF introduces another condition that Tableau checks when the preceding conditions have not matched.

Q4. What happens when ELSE is omitted?

Answer: If no condition matches, an IF or CASE calculation without a matching branch or default result returns NULL.

Q5. What is the difference between IF and CASE?

Answer: IF can evaluate different logical tests, while CASE compares one expression against specified values. CASE is convenient for mapping categories to labels.

Q6. What is the IIF function?

Answer: IIF is a compact conditional function that returns a result for a true test and another result for a false test. It also supports an optional result for an unknown test.

Q7. Why does condition order matter?

Answer: Tableau returns the result associated with the first true condition. If an earlier condition is too broad, later conditions may never be reached.

Q8. What is the difference between AND and OR?

Answer: AND requires all included conditions to be true. OR requires at least one condition to be true.

Q9. How can you classify profitable and loss-making transactions?

Answer:

IF [Profit] > 0 THEN "Profit"
ELSEIF [Profit] = 0 THEN "Break-Even"
ELSE "Loss"
END

Q10. How can you classify sales into multiple levels?

Answer: Use IF with ELSEIF to test sales thresholds in a deliberate order, from the highest threshold to the lowest when the ranges overlap.

Q11. How do you handle NULL values?

Answer: Functions such as ISNULL, IFNULL, and ZN can help handle NULLs. The correct method depends on whether missing values should remain unknown, receive a label, or be treated as zero.

Q12. What does SUM([Sales]) do inside a conditional calculation?

Answer: It evaluates aggregated sales at the level of the current view. This differs from evaluating Sales separately for each underlying record.

Q13. What is a conditional flag?

Answer: It is a calculated field that marks records meeting a rule, often with 1 for qualifying records and 0 for others. Summing the flag can count qualifying rows when each row represents one relevant record.

Q14. Can conditional calculations be used in dashboards?

Answer: Yes. They can drive chart categories, colors, filters, labels, KPI statuses, and other dashboard elements.

Q15. What is a common mistake in conditional calculations?

Answer: Common mistakes include incorrect condition order, missing END, inconsistent data types, unintended NULL handling, and mixing aggregate with non-aggregate expressions.

27. Quick Revision Checklist

• Understand the purpose of conditional calculations.
• Know the syntax of IF, ELSEIF, ELSE, and END.
• Understand the difference between IF, IIF, and CASE.
• Use AND, OR, and NOT correctly.
• Apply comparison operators to numerical, date, and text fields.
• Order threshold conditions correctly.
• Handle NULL values according to the business requirement.
• Understand row-level versus aggregate-level calculations.
• Create calculated fields and use them in visualizations.
• Test boundary values and verify totals.
• Build a dashboard using conditional categories and KPI labels.

28. Conclusion

Conditional calculations are an essential Tableau skill for transforming data into actionable business information. By mastering IF, ELSEIF, ELSE, IIF, CASE, logical operators, NULL handling, and aggregation-aware logic, you can classify records, measure target achievement, analyze profit and loss, segment customers, identify transactions for review, and build interactive dashboards.

The most important habit is to define the business rule clearly before writing the formula. Then test boundary values, inspect missing data, confirm the intended level of aggregation, and validate the results against the underlying records.

29. Learn Tableau with JustAcademy

Explore the course and use the demo registration link to learn more about Tableau training.

• JustAcademy Tableau Training
• Register for a Tableau Course Demo

Additional Learning Resource

Official Tableau Documentation: Logical Functions